CREATE PROCEDURE GetFromClienteByNombre
@nombre_razsocial varchar(30)
AS
BEGIN
SELECT *
FROM Cliente
WHERE upper(razon_social) LIKE upper('%'+@nombre_razsocial+'%')
END